Aside

Michael Hanna

Contact Info

Personal Statement

My engineering background, operational experience, and strong computer skills provide a deep understanding of business needs and data flows that allow me to produce user-friendly and efficient solutions that cover the whole data life cycle from data capture, quality control, and extraction to data manipulation, visualization, and analysis.

Skills

  • Highly Skilled in R Programming
  • Proficient with SQL Scripting
  • Proficient with Azure Data Factory
  • Proficient with TIBCO Spotfire
  • Proficient with Excel and VBA
  • Accurate, Reliable, and Quick-Learner

Main

Michael Hanna

Data Scientist/Data Engineer leveraging 15 years of high-pressure operational experience in the energy sector looking to deliver value to a new industry and organization. Please check my cover letter here, and my resume in pdf can be found here!

Professional Experience

Data Scientist - Business Intelligence

EQT Corporation

Pittsburgh, PA

Aug 2020 - Current

  • Work in special projects & initiatives of strategic importance to the Company such as building EQT’s ESG platform (Environmental, Social, and Governance), ERP migration project, etc.
  • Update and maintain internal R package allowing the Team to easily Extract, Transform, and Load (ETL) data between source applications and Azure Data Lake Storage (ADLS) and finally publishing it to Synapse Analytics.
  • Participate in setting processes and standards for architecting, building, and configuring Azure Modern Data Warehouse.

Data Engineer - Data Governance & Advanced Analytics

EQT Corporation

Pittsburgh, PA

Jun 2017 - Aug 2020

  • Create Data Pipelines using R, Azure Data Factory, Synapse Analytics, and Informatica Cloud.
  • Develop insights using Tibco Spotfire, Microsoft Power BI, and R Shiny apps as needed.
  • Report quarterly drilling performance and KPIs to the management.
  • Create and deploy all Wellview drilling data audits to ensure data reliability.
  • Manage work using cases and work items in Salesforce and repositories in Github.

Wells Performance Analyst - Global Wells Organization

BP

Anchorage, Alaska

Apr 2012 - May 2017

  • Develop Excel automated tools using VBA for end of well reporting, wellbore integrity testing calculator, well scorecard, and data quality audits.
  • Provide support to the drilling and workover teams by responding to ad-hoc data requests, answering questions, and providing analysis.
  • Act as Landmark applications point of contact for OpenWells, Compass, and Data Analyzer.
  • Create and maintain GWO (Global Wells Organization) Spotfire interactive dashboards.
  • Compile and manipulate data from different sources to assist with technical analysis (EDM, AWGRS, Finder, SAP Business Objects,…etc.)
  • Assist in Drilling Performance Benchmarking and KPIs.
  • Update the company legacy tools to comply with the new policies and best practices.

Senior Drilling Data Management Engineer

MCS Freezone (Modern Computing Services)

Cairo, Egypt

Mar 2006 - Sep 2011

  • Research, gather requirements, design, install, configure, troubleshoot, train, and support MCS drilling applications.
  • Report the Drilling Performance, NPT, root cause analysis, and learning curve management.
  • Support data acquisition, data entry, data quality control, and end of well reporting.
  • Implement the first Kongsberg real-time drilling data management system in the Egyptian market.
  • Install and run PMAC sand monitoring system on an offshore rig in Mauritania.
  • Manage and supervise three of MCS Junior Drilling Engineers

DRILLING APPS

  • Proficient with Landmark EDM Suite (OpenWells, Compass, Data Analyzer, and Profile)
  • Proficient with Peloton Wellview
  • Proficient with Petrobeacon Spotlight Audit App
  • Proficient with Genesis Analyzer, Designer and Data Entry System (DES)
  • Proficient with the Drilling Performance KPIs and End of Well Reporting

SKILLS ACTIVELY LEARNING

  • Python
  • Databricks
  • Power BI and DAX Language

REFERENCES

Scan this barcode with your iPhone camera to look at recommendations on my LinkedIn profile.
Additional references are available upon request.


This resume was created using the R package pagedown.

Last updated on 2021-06-10

Roughneck

Global SantaFE Corporation, Offshore Key Manhattan Jackup Rig

Port Said, Egypt

Nov 2004 - Feb 2006

Education

Cairo University - Faculty of Engineering

B.Sc. in Petroleum Engineering

Cairo, Egypt

1998 - 2003

Official Credential Evaluation Report from IERF (International Education Research Foundation) - a member of NACES (National Association of Credential Evaluation Services) is available upon request.

Selected achievements

EQT

N/A

N/A

N/A

  • Developed ESG Platform to calculate EQT’s Greenhouse Gas Emissions for EPA and State reporting purposes, and to forecast the emissions for the next 5 years based on the operation schedule. This platform is a cornerstone in EQT’s path toward net-zero emissions.
  • Developed R package with a variety of functions to allow easy interactions with Azure Data Lake & Azure Synapse Analytics using different file formats, and securing the credentials using config files. The functions also offer built-in QC for the written data frames prior to truncating existing tables by adding proper error handling techniques and logging the errors in the relevant databases. This prevented erroneous data to be fed downstream and improved the stability of our scripts.
  • Automated weekly emails pulling data from Azure SQL database and sending them to joint-venture partners using R.
  • Created a Drilling Sandbox, which is a self-service Spotfire dashboard that allows the user to easily tweak a number of desired inputs and axes to answer thousands of different operational performance questions used for internal and external corporate communications, but which used to take hours to answer and verify prior to this tool’s implementation.

BP

N/A

N/A

N/A

  • Developed and maintained the first Spotfire dashboards in GWO Alaska. Received global recognition from BP.
  • Created “Wellbore Integrity Testing Criteria Calculator” which determines if the test pressure results meet the acceptance criteria according to “BP Site Technical Practice CRT-AK-10-45: Working with Pressure”.
  • Created the Drilling Data Reporter (DDR) which is a fully automated Excel tool that pulls data from EDM oracle database and generates several performance and data quality reports.

EGYPT

N/A

N/A

N/A

  • Awarded a certificate for my successful participation in the “In-House SPE Student Technical Paper Contest”, Cairo, Egypt, 2003.